Skip Headers

Oracle® OLAP DML Reference 10g Release 2 (10.2) Part Number B14346-01 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# STATIC_SESSION_LANGUAGE

The STATIC_SESSION_LANGUAGE option is a read-write option that controls whether or not Oracle OLAP keeps the value of the SESSION_NLS_LANGUAGE option synchronized with the value of the NLS_LANGUAGE option.

See also: "Working with Language Dimensions", $DEFAULT_LANGUAGE, SESSION_NLS_LANGUAGE, and LOCK_LANGUAGE_DIMS.

Data Type

BOOLEAN

Syntax

STATIC_SESSION_LANGUAGE = NO | YES

Arguments

NO

  Specifies that whenever the value of the NLS_LANGUAGE option changes, Oracle OLAP changes the value of SESSION_NLS_LANGUAGE to the value of the NLS_LANGUAGE option. (Default)

YES

  Specifies that the value of SESSION_NLS_LANGUAGE does not change when the value of NLS_LANGUAGE changes.

Examples

Example 22-43 Changing NLS_LANGUAGE Without Changing the Language of the OLAP Session

Example 6-8, "Changing NLS_LANGUAGE" illustrates how changing the NLS_LANGUAGE value can change the language of the OLAP session. This example illustrates how you can keep the language of the OLAP session the same even as the value of the NLS_LANGUAGE option changes.

Assume that you attach your analytic workspace while the NLS_LANGUAGE is American. As the following code illustrates by changing the value of the STATIC_SESSION_LANGUAGE to Yes, you can insure that even as the value of the NLS_LANGUAGE option is changed to French, the value of the SESSION_NLS_LANGUAGE stays American which means that Oracle OLAP limits the language dimension (`mylangs`) to American.

    SHOW NLS_LANGUAGEFRENCH
    AMERICAN

    " Make the session language static
    STATIC_SESSION_LANGUAGE = yes

    "Change the value of NLS_LANGUAGE to FRENCH
    SET NLS_LANGUAGE= 'FRENCH'

    SHOW OBJ(PROPERTY '$DEFAULT_LANGUAGE' 'mylangs')
    AMERICAN
    SHOW NLS_LANGUAGE
    FRENCH
    SHOW SESSION_NLS_LANGUAGE
    AMERICAN
    SHOW LOCK_LANGUAGE_DIMS
    oui
    SHOW STATIC_SESSION_LANGUAGE
    oui

    REPORT mylangs
    MYLANGS
    --------------
    AMERICAN

    REPORT prod_desc
                   ------PROD_DESC------
                   ------PRODUCTS-------
    MYLANGS          PROD01     PROD02
    -------------- ---------- ----------
    AMERICAN       Trousers   Skirts